home *** CD-ROM | disk | FTP | other *** search
/ PC World 2008 April / PCWorld_2008-04_cd.bin / temacd / pspad / pspad453inst_cz(2).exe / {app} / Context / SAS.def < prev    next >
Encoding:
Text File  |  2005-09-24  |  11.2 KB  |  441 lines
  1. ; PSPad code template for SAS
  2. ; Created by JSK okt 2003
  3. ;
  4.  
  5. [Macro definition]
  6. %TableName%=@E Table name:,,,,
  7. %Package%=@E Package:,,,,
  8. %Author%=@E Author:,,,,
  9. %Date%=@D Date:,,,,
  10. ;
  11. ;
  12. [COMMENT |r COMMENT BLOCK]
  13. /*
  14. |ยบ
  15. */
  16. [IF | IF  END IF]
  17. IF | THEN
  18. END IF;
  19. [IFE | IF ELSE END IF]
  20. IF | THEN
  21.   NULL;
  22. ELSE
  23.   NULL;
  24. END IF;
  25. [IFI | IF ELSIF  END IF]
  26. IF | THEN
  27.   NULL;
  28. ELSIF THEN
  29.   NULL;
  30. ELSIF THEN
  31.   NULL;
  32. ELSIF THEN
  33.   NULL;
  34. ELSE
  35. END IF;
  36. [FOR iCnt | FOR iCnt IN .. LOOP]
  37. FOR iCnt IN |.. LOOP
  38. END LOOP;
  39. [FOR o | FOR o IN (SELECT LOOP]
  40. FOR o| IN  ( SELECT
  41.            )
  42. LOOP
  43.   NULL;
  44. END LOOP;
  45. ;
  46. ;
  47. --------------------------------------------------------------------------------
  48. [PROC SORT |m PROC SORT]*CTRL+ALT+S
  49. PROC SORT DATA=%TableName% <option(s)> <collating-sequence-option>;
  50.     BY <DESCENDING> variable-1 <...<DESCENDING> variable-n>;
  51. --------------------------------------------------------------------------------
  52. [PROC APPEND |m PROC APPEND]*CTRL+ALT+A
  53. PROC APPEND BASE=<libref.>SAS-data-set
  54.     <DATA=<libref.>SAS-data-set>
  55.     <FORCE>
  56.     <APPENDVER=V6>;
  57. --------------------------------------------------------------------------------
  58. [PROC COMPARE |m PROC COMPARE]*CTRL+ALT+C
  59. PROC COMPARE <option(s)>;
  60.     BY <DESCENDING> variable-1
  61.     <...<DESCENDING> variable-n>
  62.     <NOTSORTED>;
  63.  
  64.     ID <DESCENDING> variable-1
  65.     <...<DESCENDING> variable-n>
  66.     <NOTSORTED>;
  67.  
  68.      VAR variable(s);
  69.  
  70.      WITH variable(s);
  71. --------------------------------------------------------------------------------
  72. [PROC CONTENTS |m PROC CONTENTS]*
  73. PROC CONTENTS < option(s) >;
  74. --------------------------------------------------------------------------------
  75. [PROC COPY |m PROC COPY]*
  76. PROC COPY OUT=libref-1 IN=libref-2
  77.     <CLONE|NOCLONE>
  78.     <CONSTRAINT=YES|NO>
  79.     <DATECOPY>
  80.     <INDEX=YES|NO>
  81.     <MEMTYPE=(mtype(s))>
  82.     <MOVE <ALTER=alter-password>>;
  83.  
  84.     EXCLUDE SAS-file(s)
  85.     </ MEMTYPE=mtype>;
  86.  
  87.      SELECT SAS-file(s)
  88.     </ <MEMTYPE=mtype>
  89.     <ALTER=alter-password>>;
  90.     /*
  91.     Note:   IN=libref-1 is required on PROC COPY, but is optional on the COPY
  92.     statement
  93.     */
  94. --------------------------------------------------------------------------------
  95. [PROC DATASETS |m PROC DATASETS]*
  96. PROC DATASETS < option(s) >;
  97.     AGE current-name related-SAS-file(s)
  98.     </ <ALTER=alter-password>
  99.     <MEMTYPE=mtype>>;
  100.  
  101.      APPEND BASE= <libref.>SAS-data-set
  102.         <APPENDVER=V6>
  103.         <DATA=<libref.>SAS-data-set>
  104.         <GENNUM=integer>
  105.         <FORCE>;
  106.  
  107.     AUDIT SAS-file-name <SAS-password>;
  108.         INITIATE;
  109.         <LOG < BEFORE_IMAGE=YES|NO>
  110.         <DATA_IMAGE=YES|NO>
  111.         <ERROR_IMAGE=YES|NO>>;
  112.         <USER_VAR=variable-1 <... variable-n>>;
  113.  
  114.         or
  115.  
  116.     AUDIT SAS-file-name <SAS-password><GENNUM= integer>;
  117.         SUSPEND|RESUME|TERMINATE;
  118.  
  119.      CHANGE old-name-1=new-name-1
  120.     <...old-name-n=new-name-n >
  121.     </ <ALTER=alter-password>
  122.     <GENNUM=ALL|integer>
  123.     <MEMTYPE=mtype>>;
  124.  
  125.      CONTENTS < option(s)>;
  126.  
  127.      COPY OUT=libref-1
  128.     <CLONE|NOCLONE>
  129.     <CONSTRAINT=YES|NO>
  130.     <IN=libref-2>
  131.     <INDEX=YES|NO>
  132.     <MEMTYPE=(mtype(s))>
  133.     <MOVE <ALTER=alter-password>;>
  134.  
  135.     EXCLUDE SAS-file(s) < / MEMTYPE=mtype>;
  136.  
  137.      SELECT SAS-file(s)
  138.     </ <ALTER=alter-password>
  139.     <MEMTYPE= mtype>>;
  140.  
  141.      DELETE SAS-file(s)
  142.     </ <ALTER=alter-password>
  143.     <GENNUM=ALL|HIST|REVERT|integer>
  144.     <MEMTYPE=mtype>>;
  145.  
  146.  
  147.      EXCHANGE name-1=other-name-1
  148.     <...name-n=other-name-n>
  149.     </ <ALTER=alter-password>
  150.     <MEMTYPE=mtype> >;
  151.  
  152.  
  153.      MODIFY SAS-file <(file-option(s))>
  154.     </ <GENNUM=integer> 
  155.     <MEMTYPE=mtype>>;  FORMAT variable-list-1 <format-1> 
  156.     <...variable-list-n <format-n>>;  
  157.     
  158.     IC CREATE <constraint-name>= (NOT NULL (variable) | 
  159.     CHECK(WHERE-expression) | 
  160.     PRIMARY KEY (variables) | 
  161.     UNIQUE (variables) | 
  162.     FOREIGN KEY (variables) REFERENCES <libref>.SAS-data-set 
  163.     <ON DELETE referential-action> <ON UPDATE referential-action>) 
  164.     <MESSAGE='message-string' <MSGTYPE=USER>>;  
  165.     
  166.     
  167.      IC DELETE constraint-name(s)| _ALL_;  
  168.     
  169.     
  170.      IC REACTIVATE foreign-key-name REFERENCES libref;  
  171.     
  172.     
  173.      INDEX CENTILES index(s) 
  174.     </ <REFRESH>
  175.     <UPDATECENTILES= 
  176.     ALWAYS|NEVER|integer> >;
  177.  
  178.     
  179.      INDEX CREATE index-specification(s) 
  180.     </ <NOMISS> 
  181.     <UNIQUE> 
  182.     <UPDATECENTILES= 
  183.     ALWAYS|NEVER|integer>>;  
  184.     
  185.     
  186.      INDEX DELETE index(s)|_ALL_;  
  187.     
  188.     
  189.      INFORMAT variable-list-1 <informat-1> 
  190.     <...variable-list-n <informat-n>>;  
  191.     
  192.     
  193.      LABEL variable-1=<'label-1'|' '> 
  194.     <...variable-n=<'label-n'|' ' >>;  
  195.     
  196.     
  197.      RENAME old-name-1=new-name-1 
  198.     <...old-name-n=new-name-n>;  
  199.     
  200.     
  201.      
  202.     
  203.     
  204.      REPAIR SAS-file(s) 
  205.     </ <ALTER=alter-password>
  206.     <GENNUM=integer>
  207.     <MEMTYPE=mtype>>;
  208.  
  209.  
  210.      SAVE SAS-file(s) </ MEMTYPE=mtype>;
  211. --------------------------------------------------------------------------------
  212. [PROC EXPORT |m PROC EXPORT]*
  213. PROC EXPORT DATA=SAS-data-set
  214.     OUTFILE="filename" | OUTTABLE="tablename"
  215.     <DBMS=identifier> <REPLACE>;  < data-source-statements;>
  216.  
  217. --------------------------------------------------------------------------------
  218. [PROC FORMAT |m PROC FORMAT]*
  219. PROC FORMAT <option(s)>;  EXCLUDE entry(s);
  220.  
  221.     INVALUE <$>name <(informat-option(s))> value-range-set(s);
  222.  
  223.     PICTURE name <(format-option(s))>
  224.     value-range-set-1 <(picture-1-option(s) )>
  225.     <...value-range-set-n <(picture-n-option(s))>>;
  226.  
  227.     SELECT entry(s);
  228.  
  229.     VALUE <$>name <(format-option(s))> value-range-set(s);
  230. --------------------------------------------------------------------------------
  231. [PROC FREQ |m PROC FREQ]*
  232. PROC FREQ <option(s)>;  BY <DESCENDING> variable-1 <...<DESCENDING> variable-n>
  233.     <NOTSORTED>;
  234.  
  235.     EXACT statistic-keyword(s) </ option(s)>;
  236.  
  237.     OUTPUT statistic-keyword(s) <OUT=SAS-data-set>;
  238.  
  239.     TABLES request(s) </ option(s)>;
  240.  
  241.     TEST statistic-keyword(s);
  242.  
  243.     WEIGHT variable;
  244. --------------------------------------------------------------------------------
  245. [PROC IMPORT |m PROC IMPORT]*
  246. PROC IMPORT
  247.     DATAFILE="filename" | TABLE="tablename"
  248.     OUT=SAS-data-set
  249.     <DBMS=identifier><REPLACE>;  < data-source-statements;>
  250.     
  251. --------------------------------------------------------------------------------
  252. [PROC MEANS |m PROC MEANS]*
  253. PROC MEANS <option(s)> <statistic-keyword(s)>;
  254.     BY <DESCENDING> variable-1 <... <DESCENDING> variable-n><NOTSORTED>;
  255.  
  256.     CLASS variable(s) </ option(s)>;
  257.  
  258.     FREQ variable;
  259.  
  260.     ID variable(s);
  261.  
  262.     OUTPUT <OUT=SAS-data-set> <output-statistic-specification(s)>
  263.         <id-group-specification(s)> <maximum-id-specification(s)>
  264.         <minimum-id-specification(s)> </ option(s)> ;
  265.  
  266.     TYPES request(s);
  267.  
  268.     VAR variable(s) < / WEIGHT=weight-variable>;
  269.  
  270.     WAYS list;
  271.  
  272.     WEIGHT variable;
  273.  
  274. --------------------------------------------------------------------------------
  275. [PROC PRINT |m PROC PRINT]*
  276. PROC PRINT < option(s)>;
  277.     BY < DESCENDING> variable-1  <...< DESCENDING> variable-n>< NOTSORTED>;
  278.  
  279.     PAGEBY BY-variable;
  280.  
  281.     SUMBY BY-variable;
  282.  
  283.     ID variable(s);
  284.  
  285.     SUM variable(s);
  286.  
  287.     VAR variable(s);
  288.  
  289. --------------------------------------------------------------------------------
  290. [PROC REPORT |m PROC REPORT]*
  291. PROC REPORT <option(s)>;
  292.     BREAK location break-variable</ option(s)>;
  293.  
  294.     BY <DESCENDING> variable-1
  295.     <...<DESCENDING> variable-n> <NOTSORTED>;
  296.  
  297.     COLUMN column-specification(s);
  298.  
  299.     COMPUTE location <target>
  300.         </ STYLE=<style-name> <[style-attribute-specification(s)]>>;
  301.  
  302.         LINE specification(s);
  303.  
  304.         /* ... select SAS language elements ... */
  305.  
  306.     ENDCOMP;
  307.     
  308.     COMPUTE report-item </ type-specification>;
  309.         CALL DEFINE (column-id, 'attribute-name', value);
  310.  
  311.         /* ... select SAS language elements ... */
  312.  
  313.     ENDCOMP;
  314.  
  315.     DEFINE report-item / <usage>
  316.         <attribute(s)>
  317.         <option(s)>
  318.         <justification>
  319.         <COLOR=color>
  320.         <'column-header-1' <...'column-header-n'>>
  321.         <style>;
  322.  
  323.     FREQ variable;
  324.  
  325.     RBREAK location </ option(s)>;
  326.  
  327.     WEIGHT variable;
  328.  
  329. --------------------------------------------------------------------------------
  330. [PROC SQL |m PROC SQL]*
  331. PROC SQL< option-list>;
  332.     ALTER TABLE alter-statement;
  333.  
  334.     CREATE create-statement;
  335.  
  336.     DELETE delete-statement;
  337.  
  338.     DESCRIBE describe-statement;
  339.  
  340.     DROP drop-statement;
  341.  
  342.     INSERT insert-statement;
  343.  
  344.     RESET <reset statement option-list>;
  345.  
  346.     SELECT select-statement;
  347.  
  348.     UPDATE update-statement;
  349.  
  350.     VALIDATE validate-statement;
  351.  
  352. --------------------------------------------------------------------------------
  353. [PROC SUMMARY |m PROC SUMMARY]*
  354. /*
  355. See the MEANS procedure syntax for details.
  356. */
  357. PROC SUMMARY <option(s)> <statistic-keyword(s)>;
  358.     BY <DESCENDING> variable-1<...<DESCENDING> variable-n> <NOTSORTED>;
  359.  
  360.     CLASS variable(s) </ option(s)>;
  361.  
  362.     FREQ variable;
  363.  
  364.     ID variable(s);
  365.  
  366.     OUTPUT <OUT=SAS-data-set><output-statistic-specification(s)>
  367.     <id-group-specification(s)> <maximum-id-specification(s)>
  368.     <minimum-id-specification(s)></ option(s)> ;
  369.  
  370.     TYPES request(s);
  371.  
  372.     VAR variable(s)</ WEIGHT=weight-variable>;
  373.  
  374.     WAYS list;
  375.  
  376.     WEIGHT variable;
  377.  
  378. --------------------------------------------------------------------------------
  379. [PROC TABULATE |m PROC TABULATE]*
  380. PROC TABULATE <option(s)>;
  381.     BY <DESCENDING> variable-1 <...<DESCENDING> variable-n> <NOTSORTED>;
  382.  
  383.     CLASS variable(s) </ options>;
  384.  
  385.     CLASSLEV variable(s) / STYLE=<style-element-name | <PARENT>> <[style-attribute-specification(s)] >;
  386.  
  387.     FREQ variable;
  388.  
  389.     KEYLABEL keyword-1='description-1' <...keyword-n='description-n'>;
  390.  
  391.     KEYWORD keyword(s) / STYLE =<style-element-name | <PARENT>> <[style-attribute-specification(s)] >;
  392.  
  393.     TABLE <<page-expression,> row-expression,> column-expression </ table-option(s)>;
  394.  
  395.     VAR analysis-variable(s)</ options>;
  396.  
  397.     WEIGHT variable;
  398.  
  399. --------------------------------------------------------------------------------
  400. [PROC TRANSPOSE |m PROC TRANSPOSE]*
  401. PROC TRANSPOSE <DATA=input-data-set> <LABEL=label> <LET>
  402.     <NAME=name> <OUT=output-data-set> <PREFIX=prefix>;
  403.     
  404.     BY <DESCENDING> variable-1 <...<DESCENDING> variable-n> <NOTSORTED>;
  405.  
  406.     COPY variable(s);
  407.  
  408.     ID variable;  IDLABEL variable;
  409.  
  410.     VAR variable(s);
  411.  
  412. --------------------------------------------------------------------------------
  413. [PROC UNIVARIATE |m PROC UNIVARIATE]
  414. PROC UNIVARIATE <option(s)>;
  415.     BY <DESCENDING> variable-1 <...<DESCENDING> variable-n> <NOTSORTED>;
  416.  
  417.     CLASS variable-1<(variable-option(s))> <variable-2<(variable-option(s))>>
  418.         </ KEYLEVEL= 'value1'|('value1' 'value2')>;
  419.  
  420.     FREQ variable;
  421.  
  422.     HISTOGRAM <variable(s)> </ option(s)>;
  423.  
  424.     ID variable(s);
  425.  
  426.     INSET <keyword(s)> </ option(s)>;
  427.  
  428.     OUTPUT <OUT=SAS-data-set>
  429.         statistic-keyword-1=name(s)
  430.         <... statistic-keyword-n=name(s)>
  431.         <percentiles-specification>;
  432.  
  433.     PROBPLOT <variable(s)> </ option(s)>;
  434.  
  435.     QQPLOT <variable(s)> </ option(s)>;
  436.  
  437.     VAR variable(s);
  438.  
  439.     WEIGHT variable;
  440. --------------------------------------------------------------------------------
  441.